package webdev.database;

public class InfoDB {

	// DB name
	public static final String DATABASE_NAME = "danang_travel";
	// DB version
	public static final int DATABASE_VERSION = 3;

	// Table user
	public static final String TABLE_USER = "TABLE_USER";
	public static final String USER_NAME = "user_name";
    public static final String PASSWORD = "password";

    // table dia diem
    public static final String TABLE_DIA_DIEM = "TABLE_DIA_DIEM";
    public static final String ID_DIA_DIEM = "id_dia_diem";
    public static final String TITLE_DIA_DIEM = "title_dia_diem";
    public static final String DESCRIPTION_DIA_DIEM = "description_dia_diem";
    public static final String ADDRESS_DIA_DIEM = "address_dia_diem";
    public static final String PHONE_NUMBER_DIA_DIEM = "phone_num";
    public static final String IMAGE_DIA_DIEM = "image_dia_diem";
    public static final String LAT_DIA_DIEM = "lat_dia_diem";
    public static final String LNG_DIA_DIEM = "lng_dia_diem";
    public static final String TYPE_DIA_DIEM = "type";
    public static final String DIA_DIEM_VIETNAMESE = "title_place_vietnamese";
    
    // table booking
    public static final String TABLE_BOOKING = "TABLE_BOOKING";
    public static final String ID_BOOKING = "id_booking";
    public static final String NAME_USER_BOOKING = "user_name_booking";
    public static final String NAME_PLACE_BOOKING = "name_place_booking";
    public static final String TIME_ARRIVE_BOOKING = "time_arrive";
    public static final String TIME_LEAVE_BOOKING = "time_leave";
    public static final String CONTENT_BOOKING = "content_booking";

    // table comment
    public static final String TABLE_COMMENT = "TABLE_COMMENT";
    public static final String ID_COMMENT = "id_comment";
    public static final String USER_COMMENT = "user_name_comment";
    public static final String NAME_PLACE = "name_place";
    public static final String CONTENT_COMMENT = "content_comment";
}
